Tabela LServiceGroup

Definicja tabeli LServiceGroup

Name

LServiceGroup

Code

LServiceGroup

Comment

PL: Przyporzadkowanie uslugi do grupy
EN: Assignement service to a services group


Lista kolumn tabeli LServiceGroup

Name

Code

ServID

ServID

ServiceGroupID

ServiceGroupID

ICDID

ICDID

Ser_ServID

Ser_ServID

DefaultValue

DefaultValue

ShowTests

ShowTests

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna ServID tabeli LServiceGroup

Definicja kolumny ServID tabeli LServiceGroup

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServiceGroupID tabeli LServiceGroup

Definicja kolumny ServiceGroupID tabeli LServiceGroup

Name

ServiceGroupID

Code

ServiceGroupID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ICDID tabeli LServiceGroup

Definicja kolumny ICDID tabeli LServiceGroup

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Ser_ServID tabeli LServiceGroup

Definicja kolumny Ser_ServID tabeli LServiceGroup

Name

Ser_ServID

Code

Ser_ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

Profil, z którego pochodzi usluga-test


Kolumna DefaultValue tabeli LServiceGroup

Definicja kolumny DefaultValue tabeli LServiceGroup

Name

DefaultValue

Code

DefaultValue

Data Type

NUMBER(5)

Mandatory

No

Comment

Informacja o tym czy dana usluga w ramach grupy jest [-1 - obowiazkowa, 1 - domyslna, 0|null - nieobowiazkowa mozliwa do wybrania]


Kolumna ShowTests tabeli LServiceGroup

Definicja kolumny ShowTests tabeli LServiceGroup

Name

ShowTests

Code

ShowTests

Data Type

NUMBER(10)

Mandatory

No

Comment

Informuje czy podczas procesu zlecania, dla danego profilu nalezy otworzyc okienko z testami


Kolumna InsertingPerson tabeli LServiceGroup

Definicja kolumny InsertingPerson tabeli LServiceGroup

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli LServiceGroup

Definicja kolumny InsertDate tabeli LServiceGroup

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna LastModifiedPerson tabeli LServiceGroup

Definicja kolumny LastModifiedPerson tabeli LServiceGroup

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Ostatnio modyfikujaca osoba


Kolumna LastModifiedDT tabeli LServiceGroup

Definicja kolumny LastModifiedDT tabeli LServiceGroup

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli LServiceGroup

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServiceGroup

Definicja klucza Identifier_1 tabeli LServiceGroup

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment